818529b5b10bbf2f5ef861f0439ef1d84fc69577,src/main/java/org/springframework/samples/petclinic/repository/jdbc/JdbcVisitRepositoryImpl.java,JdbcVisitRepositoryImpl,findByPetId,#number#,92

Before Change



    @Override
    public List<Visit> findByPetId(Integer petId) {
        final List<Visit> visits = this.jdbcTemplate.query(
                "SELECT id, visit_date, description FROM visits WHERE pet_id=?",
                new BeanPropertyRowMapper<Visit>() {
                    @Override
                    public Visit mapRow(ResultSet rs, int row) throws SQLException {
                        Visit visit = new Visit();
                        visit.setId(rs.getInt("id"));
                        Date visitDate = rs.getDate("visit_date");
                        visit.setDate(new DateTime(visitDate));
                        visit.setDescription(rs.getString("description"));
                        return visit;
                    }
                },
                petId);
        return visits;
    }

}

After Change



    @Override
    public List<Visit> findByPetId(Integer petId) {
        return this.jdbcTemplate.query(
                "SELECT id as visit_id, visit_date, description FROM visits WHERE pet_id=?",
                new JdbcVisitRowMapper(), petId);
    }

}